How to: Arrange multiple workbook windows.
Solution:
Select 'Arrange...' from the 'Window' menu, select the appropriate option, and choose 'OK'.
1) Select the 'Window' menu and select 'Arrange...'. (The Arrange Windows dialog box appears.)
2) Select one of the following options from the 'Arrange' group to arrange all the open workbook windows:
a) Select the 'Tiled' radio button to arrange the windows vertically and horizontally without overlapping.
b) Select the 'Vertical' radio button to arrange the windows vertically without overlapping.
c) Select the 'Horizontal' radio button to arrange the windows horizontally without overlapping.
d) Select the 'Cascade' radio button to allow the windows to overlap and to show only the title bar of each window.
3) Click 'OK'.